// ============================================================================
//
// Copyright (C) 2006-2007 Dengues
//
// Google Group: http://groups.google.com/group/dengues
// QQ Group: 24885404
//
// This library is free software; you can redistribute it and/or
// modify it under the terms of the GNU Lesser General Public
// License as published by the Free Software Foundation; either
// version 2.1 of the License.
//
// This library is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
// Lesser General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with this program; if not, write to the Free Software
// Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
//
// ============================================================================
package org.dengues.warehouse.dbmanager.ui.action;

import java.sql.Connection;
import java.util.Properties;

import org.dengues.commons.IDenguesSharedImage;
import org.dengues.commons.connectivity.EDatabaseType;
import org.dengues.commons.utils.ImageUtil;
import org.dengues.core.DenguesCorePlugin;
import org.dengues.core.IDesignerCoreService;
import org.dengues.core.actions.AbstractAction;
import org.dengues.core.connectivity.IConnectivityManager;
import org.dengues.core.connectivity.IConnectivityProperty;
import org.dengues.core.metadata.DatabaseContainer;
import org.dengues.ui.prefs.connectivity.EConnectivityProperties;
import org.dengues.warehouse.dbmanager.ui.DatabaseManagerDialog;
import org.dengues.warehouse.i18n.Messages;
import org.eclipse.jface.dialogs.MessageDialog;
import org.eclipse.jface.dialogs.TrayDialog;
import org.eclipse.swt.widgets.Display;
import org.eclipse.swt.widgets.Shell;

/**
 * Qiang.Zhang.Adolf@gmail.com class global comment. Detailled comment <br/>
 * 
 * $Id: Dengues.epf 2007-11-26 qiang.zhang $
 * 
 */
public class DatabaseManageAction extends AbstractAction {

    private DatabaseContainer container;

    /**
     * Qiang.Zhang.Adolf@gmail.com EditQueryAction constructor comment.
     */
    public DatabaseManageAction() {
        super(Messages.getString("EditQueryAction.Label")); //$NON-NLS-1$
        setImageDescriptor(ImageUtil.getDescriptor(IDenguesSharedImage.ACTION_OPTIONDB));
    }

    /*
     * (non-Javadoc)
     * 
     * @see org.eclipse.jface.action.Action#run()
     */
    @Override
    public void run() {

        Properties baseProperties = null;
        DenguesCorePlugin default1 = DenguesCorePlugin.getDefault();
        IConnectivityManager manager = default1.getDenguesUiService().getConnectivityManager();
        IConnectivityProperty connectivityProperty = default1.getWarehousePluginService().openSelectConnSetDialog(false);
        if (connectivityProperty != null) {
            baseProperties = connectivityProperty.getBaseProperties();
            manager.getConnection(baseProperties, true, EDatabaseType.isNestedDriverFromDriver(baseProperties
                    .get(EConnectivityProperties.PROP_ID_DRIVER.getPropId())));
        } else {
            return;
        }
        boolean openQuestion = manager.getConnection() != null;
        Connection connection = manager.getConnection();
        IDesignerCoreService designerCoreService = default1.getDesignerCoreService();
        if (openQuestion) {
            container = designerCoreService.getDatabaseContainerFrommConnection(manager.getConnection(), baseProperties);
        } else {
            // connection = designerCoreService.getCurrentConnection();
            // container = designerCoreService.getHsqlDatabase();
            // openQuestion = true;
            openQuestion = MessageDialog.openQuestion(new Shell(),
                    Messages.getString("EditQueryAction.Confirm.Title"), Messages.getString("EditQueryAction.Confirm.Info")); //$NON-NLS-1$ //$NON-NLS-2$
        }
        if (openQuestion) {
            TrayDialog sqlDialog = new DatabaseManagerDialog(Display.getCurrent().getActiveShell(), container, connection);
            sqlDialog.open();
        }
        manager.closeConnection();
        container = null;
    }

    /*
     * (non-Javadoc)
     * 
     * @see org.dengues.core.actions.AbstractAction#computeEnable()
     */
    @Override
    protected boolean computeEnable() {
        return false;
    }
}
